Set Precedence to NULL

Optional

If this option is selected, the database value is set to null. In an update request, if the NULL attribute is set to 'True' and data is specified, the database value will still be null.

Note: This is applicable to DBSQL methods only.

Support Special Characters in XML

Optional

Select this option if your table names or column names contain characters which are not valid XML tag names. Process Platform supports @, #, $ and space as special character in table names and column names. The encoding or decoding of special characters in XML takes more time and this may slow down the performance of your computer. In case the database does not contain any table or field with the above four XML special characters, you can clear this check box for improved performance.

Note: Process Platform support only @, #, $, and space as part of table names and column names. If the table has any other special characters, which are invalid in XML names (such as / and ), then the XML becomes invalid.

Support Multibyte

Optional

Select this option for an application, if you want to store multibyte data in columns which are created with non-unicode data type (for example, varchar).

If the column data type supports unicode or multibyte data storage (like nvarchar data type), then this option is not needed.

When this option is enabled, all non-unicode data types are internally mapped to unicode data types; this can lead to performance issues as many database servers (such as SQL server) do not honor indices for which the data type is changed. It is therefore recommended that this option not be used if the column data types support unicode. For example, if the data type of a table column, where multibyte data needs to stored, is nvarchar/nchar/ntext, then this option is not needed.

Note: This is applicable to OLEDB only.

Read Empty String as NULL

Optional

This property provides you an option to read the empty strings in the table as NULL character. If you set the value true, both empty strings and NULL will be returned as NULL in the result. The following XQY XML format appears when the property is set true:
<value null="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
By default, if the property is false, Process Platform distinguishes between NULL and empty strings while reading the data.
For NULL, the XML response is <value null="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>.
For empty strings, the XML response will be <value/>.

Write Empty String as NULL

Optional

Using this property you can insert NULL for empty strings automatically while passing the parameter request. If the property is set true, while inserting or updating the database, the NULL and empty strings are considered to be same. If the insert/update request contains <value/> or <value null="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>, NULL will be inserted or updated.
By default, if the property is false, Process Platform differentiates between NULL and empty strings while writing the data.

Share Connection Pool

Optional

If this option is selected, , the same connection pool can be shared by different application connectors, which are attached to the same Service Container and use the same database configuration.

Cursor Cache

Optional

• Size - The number of cursors to be cached.
  Refresh Interval - The rate at which the cursor cache is refreshed. The interval is specified in seconds. At every interval, the cache is refreshed and all unused cursors since the previous refresh are removed from the cache.

Query Cache

Optional

• Size - The number of queries (requests sent to the back-end) to be cached.
• Refresh Interval - The rate at which the query cache is refreshed. The interval is specified in seconds. When a new request arrives and it is not available in the cache, the connector tries to allocate memory to the request from the existing cache. To accommodate this memory requirement, the cache is refreshed at every interval, and all unused queries since the previous refresh are removed from the cache.
  Note: The cache determines the memory requirements of the connector, and hence must be prescribed appropriately. The cache details are applicable to every connection that the user creates.

Database Connections

Optional

• Read - The values in fieldsMinimumandMaximumindicate the minimum and maximum number of Read connections to be used by the connector to accommodate multiple Read requests.
• Update - The values in fieldsMinimumandMaximumindicate the minimum and maximum number of Update connections to be used by the connector to accommodate multiple Update requests.
  Note: To accommodate several Read and Update requests at a time, the number of connections increase till the specified maximum value.
• Refresh Interval - The rate at which the Database Connections cache is refreshed. The interval is specified in seconds. At every interval, the connection pool is refreshed and all unused and idle connections since the previous refresh are removed from the cache. At any point in time, the connection pool will maintain the minimum number of connections, as specified.

Query Language

Optional

• DBSQL: By default, DBSQL is the query type for OLEDB and JDBC drivers. The performance of DBSQL queries is faster when compared with DBVIEW. But, some of the DBSQL queries may not function properly for OLEDB driver.
• DBVIEW: The performance of the DBVIEW queries is slower than DBSQL. However, many of the DBVIEW queries function properly with all kinds of drivers.
• Allow Query Language Fallback: Select this check box to enable the fall back option for Query languages from DBSQL to DBVIEW.
  Note: Allow Query Language Fallback property is applicable for OLEDB driver only.